SnowPro Core COF-C03 Best Training Material and Practice Test Q&A from CertLibrary.com

Question 1

Departments A and B both need to access the same data, but sensitive information needs to be hidden from department B.
How should this be accomplished?

A. Create and share a report with department B that does not contain the sensitive data.
B. Set up a masking policy on the sensitive data.
C. Build separate data marts and reports for each department.
D. Restrict department B’s access to columns with sensitive data.

Answer : B

Question 2

Which methods for a second factor of authentication does Snowflake support? (Choose two.)

A. Email codes
B. Authenticator applications
C. Social logins
D. Passkeys
E. Security questions

Answer : BD

Question 3

Which action can be performed by the SYSADMIN role without requiring elevated privileges from the ACCOUNTADMIN or SECURITYADMIN role?

A. Granting privileges
B. Creating a new user
C. Managing virtual warehouses
D. Viewing billing and usage information

Answer : C

Question 4

Which security features are used to control inbound access to Snowflake and internal stages? (Choose two.)

A. Network rules
B. Feature policies
C. Network policies
D. Packages policies
E. Authentication policies

Answer : CE

Question 5

Which built-in function should be used to determine if the current role has inherited privileges from another specified role?

A. INVOKER_ROLE
B. CURRENT_ROLE
C. IS_ROLE—IN_SESSION
D. CURRENT_ROLE_TYPE

Answer : C

Question 6

A Snowflake user is using the QUERY_HISTORY view in the ACCOUNT_USAGE schema to gather information about two queries that ran in the past 10 minutes, but the expected data is missing.
What would cause this to occur?

A. The queries were run on a multi-cluster virtual warehouse.
B. The queries were able to take advantage of the results cache.
C. The ACCOUNT_USAGE schema does not provide real-time results.
D. The user does not have privileges to access the QUERY_HISTORY view.

Answer : C

Question 7

Which feature allows a user to review the monthly projected costs of a Snowflake resource against the monthly actual costs?

A. Budgets
B. Auto-suspend
C. Scaling Policy
D. Resource monitor

Answer : A

Question 8

A team needs to monitor and receive alerts for Snowpipe credit usage.
Why should a custom budget be used instead of a resource monitor?

A. The custom budget is the only tool that can automatically send alert emails to users outside the ACCOUNTADMIN role.
B. Resource monitors can only track costs for one virtual warehouse, but custom budgets monitor the entire account.
C. Custom budgets track historical spending, while a resource monitor provides a cost forecast.
D. Custom budgets can track costs by object tags and include serverless features.

Answer : D

Question 9

These application roles exist in a company's environment: DEVELOPER_ROLE and ETL_ROLE. Both roles have been granted USAGE, CREATE, and SELECT privileges on the same database and schema table object.
A user with the DEVELOPER_ROLE creates a new table named MYTABLE within the MYDB.MYSCH schema. When a user with the ETL_ROLE attempts to access MYDB.MYSCH.MYTABLE, they receive an error indicating insufficient privileges.
Which statement will enable the ETL_ROLE to access MYDB.MYSCH.MYTABLE upon its creation?

A. GRANT SELECT ON TABLE MYTABLE TO ROLE ETL_ROLE;
B. GRANT SELECT ON TABLE MYTABLE TO ROLE DEVELOPER_ROLE;
C. GRANT SELECT ON FUTURE TABLES IN SCHEMA MYSCH TO ROLE ETL_ROLE;
D. GRANT SELECT ON FUTURE TABLES IN SCHEMA MYSCH TO ROLE DEVELOPER_ROLE;

Answer : C

Question 10

Which security feature supports the replacement of active keys to enhance key-pair authentication?

A. Authentication
B. Passkeys
C. Rotation
D. Time-based one-time passcodes

Answer : C

Question 11

Which function is used to retrieve all errors of the past execution of a COPY INTO <table> command?

A. LIST
B. VALIDATE
C. RESULT_SCAN
D. COPY_HISTORY

Answer : B

Question 12

Which should be used for near real-time feedback on data ingestion and ensuring the data is almost instantly available for analysis?

A. Snowpipe
B. The COPY INTO <table> command
C. Streams
D. Snowpipe Streaming

Answer : D

Question 13

A user needs to load Snowflake files from a stage that contains data from the past 5 years while using the LEAST amount of operational overhead. The file names include the year in this format:
SALES_2025_01.gz.
What command should be used to load the data from 2024?

A. The COPY INTO command to individually load the needed files.
B. The COPY INTO command using the PATTERN parameter to define the needed files.
C. The REMOVE command to eliminate unwanted files, then use the COPY INTO command.
D. The GET command to download the needed files, then create a new stage and load the files onto the stage using the COPY INTO command.

Answer : B

Question 14

A data team needs to connect Snowflake to a remote Git repository over a public network using a personal access token for authentication.
Which components should be created in Snowflake to implement this connection? (Choose two.)

A. Storage integration
B. Azure Private Link
C. A secret
D. An API integration
E. A security integration

Answer : CE

Question 15

How can a user optimize the performance of a COPY INTO <table> query that is being run on a very large file?

A. Split the file into smaller files.
B. Increase the virtual warehouse size.
C. Set the SIZE_LIMIT option to be larger than the file size.
D. Set the COMPRESSION = AUTO option in the file format.

Answer : A

SnowPro Core COF-C03 v1.0

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Talk to us!